package com.chdwmp.product.mapper;

import com.chdwmp.product.bean.app.Activation;
import com.chdwmp.product.bean.app.SerialActiveVo;
import com.chdwmp.product.bean.app.SerialNumberInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Auther: LLL
 * @Date: 2021/3/29 21:10
 * @Description:
 */
@Mapper
public interface SerialNumberMapper {


    SerialNumberInfo getTestSerialNumbers();

    void updateTestServiceNumber(String id);

    void updateTestServiceNumberByRecovery(String number);

    String queryCurrentKeepLivedCreateTime(String imei);

    String queryActivationSerialNumber();

    int querySerialNumberCount(String imei);

    Activation queryActivationSerialNumberInfo(String imei);

    void updateActivationStatus(String number);

    List<String> queryRecycleLicenseList();

    String queryCreateTimeBySeriaNumber(String number);

    int  queryDeviceList(@Param("imei") String imei,@Param("number")String number);

    int updateDeviceStatusBySeriaNumber(String s);

    List<Integer> queryAgentIdByName(@Param("first_class_customer_name") String first_class_customer_name);

    int queryAgentIsBuyProduct(@Param("agentId") String agentId, @Param("productId")String productId);

    List<Integer> queryBindProductId(String first_class_customer_name);

    List<String> queryBindProductIdList(String imei);

    int queryImeiIsExits(String imei);

    String querySerialNumberByImei(String imei);

    int queryProductIsExits(@Param("product_id") String product_id,@Param("imei") String imei);

    String queryAgentIdByName1(String imei);

    void updateProductIdByImei(@Param("s") String s, @Param("imei") String imei);

    List<SerialActiveVo> queryAllActiveImeis();
}
